TLiteConnection Members

Properties

Name	Description
ClientLibrary	Used to set or get the SQLite client library location.
ClientLibraryVersion	Indicates the version of the SQLite3 client library.
ConnectDialog	Allows to link a TCustomConnectDialog component.
Connected	Used to establish a database connection.
ConnectString (inherited from TCustomDAConnection)	Used to specify the connection information, such as: UserName, Password, Server, etc.
ConvertEOL (inherited from TCustomDAConnection)	Allows customizing line breaks in string fields and parameters.
Database	Used to specify the name of the database to be used once a connection is open.
Debug	Used to display SQL statements being executed with their parameter values and data types.
EncryptionKey	Used to specify the encryption key for working with an encrypted database.
InTransaction (inherited from TCustomDAConnection)	Indicates whether the transaction is active.
LoginPrompt	Specifies whether a login dialog appears immediately before opening a new connection.
Options	Used to specify the behaviour of the TLiteConnection object.
Pooling	Enables or disables using connection pool.
PoolingOptions	Specifies the behaviour of connection pool.

Methods

Name	Description
ApplyUpdates (inherited from TCustomDAConnection)	Overloaded. Applies changes in datasets.
Commit (inherited from TCustomDAConnection)	Commits current transaction.
Connect (inherited from TCustomDAConnection)	Establishes a connection to the server.
CreateDataSet	Returns a new instance of TLiteQuery class and associates it with the connection object.
CreateMetaData	Returns a new instance of TLiteMetaData class and associates it with the connection object.
CreateSQL	Returns a new instance of TLiteSQL class and associates it with the connection object.
CreateTransaction	Returns a new instance of TLiteTransaction class and associates it with the connection object.
Disconnect (inherited from TCustomDAConnection)	Performs disconnect.
EncryptDatabase	Encrypt the connected database with the encryption key specified.
GetKeyFieldNames (inherited from TCustomDAConnection)	Provides a list of available key field names.
GetTableNames (inherited from TCustomDAConnection)	Provides a list of available tables names.
MonitorMessage (inherited from TCustomDAConnection)	Sends a specified message through the TCustomDASQLMonitor component.
PerformConnect (inherited from TCustomDAConnection)	Establishes a connection to the server regardless of the LoginPrompt property.
Ping (inherited from TCustomDAConnection)	Used to check state of connection to the server.
Pooled (inherited from TCustomDAConnection)	Indicates whether the connection was retrieved from the pool or newly created.
ReleaseSavepoint	Releases the specified savepoint without affecting any work that has been performed after its creation.
RemoveFromPool (inherited from TCustomDAConnection)	Marks the connection that should not be returned to the pool after disconnect.
Rollback (inherited from TCustomDAConnection)	Discards all current data changes and ends transaction.
RollbackToSavepoint	Cancels all updates for the current transaction.
Savepoint	Defines a point in the transaction to which you can roll back later.
StartTransaction	Overloaded. Begins a new user transaction.

Events

Name	Description
OnConnectionLost	This event occurs when connection was lost.
OnError	This event occurs when an error has arisen in the connection.

Request Support

DAC Forum

Provide Feedback